Problem with PHP > ODBC > M$ Access - Need to rewrite date.
I'm having problems with adding a date to an M$ Access database through PHP>ODBC which I think is because of the format of the date.
So I presume that rewriting the date would solve it but I have no experience/knowledge with doing this and this is what I need help with.
Also I don't know what format the date should be changed to, although I think it has to be "2003-01-01 00:00:00" since that is what it returns when I retrieve a record from the DB.
Anyway If someone could help me with changing the format from "DD/MM/YYY" to "YYYY-MM-DD HH:MM:SS". The HH:MM:SS part will always be 00:00:00.
I have no code to post since it's not a problem with the existing code. What I would like is if someone could either post a link where I can learn how do to this or prefferably post an example I can adapt to my needs.
Just to clarify again what exacly I need to do is change
$JobEndDate = "21/01/2003"
to
$JobEndDate = "2003-01-21 00:00:00"
Also in case it matters the date will be posted from a form.